﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Gl_mes.DAL.MesDB
{
    [Serializable]
    [Table("site_material_control_lockstock_record")]
    public class SiteMaterialControlLockstockRecord
    {
        /// <summary>
        /// ID，主键，自增长
        /// </summary>
        [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int ID { get; set; } = 0;

        /// <summary>
        /// 工单单号
        /// </summary>
        [Column("prod_number")]
        public string ProdNumber { get; set; }

        /// <summary>
        /// 计划跟踪号
        /// </summary>
        [Column("mto_number")]
        public string MtoNumber { get; set; }

        /// <summary>
        /// 成品物料号
        /// </summary>
        [Column("material_number")]
        public string MaterialNumber { get; set; }

        /// <summary>
        /// 子项物料号
        /// </summary>
        [Column("submaterial_number")]
        public string SubMaterialNumber { get; set; }

        /// <summary>
        /// 站点编码
        /// </summary>
        [Column("site_code")]
        public string SiteCode { get; set; }

        /// <summary>
        /// 计划状态
        /// </summary>
        [Column("plan_state")]
        public string PlanState { get; set; }

        /// <summary>
        /// 计划数量
        /// </summary>
        [Column("plan_qty")]
        public decimal PlanQry { get; set; }

        /// <summary>
        /// 用户ID
        /// </summary>
        [Column("userid")]
        public int UserID { get; set; }

        /// <summary>
        /// 用户名称
        /// </summary>
        [Column("username")]
        public string UserName { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [Column("create_time")]
        public DateTime CreateTime { get; set; }
    }
}
